2015-12-03 - 23421.100 - Enhancement - OSA171 - Dropship exception report #CrystalReportsSupport
Enhancement
23421.100 - OSA171 - Dropship exception report
Purpose
Need to investigate and see whether it is possible to add contracts for the dropship plants and also add TAS orders for non 9 series plants.
Admin Info
Purpose
|
Need to investigate and see whether it is possible to add contracts for the dropship plants and also add TAS orders for non 9 series plants.
|
Requested By
|
Jeffrey Mau
|
Spec Created By
|
Venakteswara Reddy D
|
Spec Created Date
|
12/03/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
OSA171 (ZMP_OOCON_Q020)
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
15
|
2
|
Documentation
|
10
|
3
|
Development/ Config
|
35
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
10
|
6
|
BEx Changes
|
10
|
|
TOTAL
|
80
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to investigate and see whether it is possible to add contracts for the dropship plants and also add TAS orders for non 9 series plants.
In Scope:
Dropship plants with item category TAN, KMN & Non Dropship plants with TAS only.
Out of Scope:
Dropship plants with other than TAS.
Solution Summary
BEx Query Changes:
1. Need to remove the plant filter from BEx Query.
2. Need to restrict the item category with TAN, KMN and TAS orders.
3. Need to create a new transport request and collect all the BEx Query changes.
Crystal Report Changes:
1. Need to update the BEx query.
2. Need to add the filter condition to restrict the item category other than TAS for non 9 series plants and TAN and KMN for 9 series plants.
Solution Details
BEx Query Changes:
1. Need to remove the plant filter from BEx Query ZMP_OOCON_Q020.
2. Need to restrict the item category with TAS, KMN and TAS orders.
3. Need to create a new transport request and collect all the BEx Query changes.
Crystal Report Changes:
1. Need to update the BEx query ZMP_OOCON_Q020.
2. Need to add the filter condition to restrict the item category other than TAS for non 9 series plants and TAN and KMN for 9 series plants.
Issues
Need to handle the restriction of item categories based on plants at crystal report which is not possible in BEx.